-----------------------------------------------------------------------------------------------------
       log:  descriptives Tables 1-3.log
  log type:  text

. use "QATARAID_RAW.dta" ,clear
(QATARAID-RAW)

. tab country

        Name of the recipient countries |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
                                      . |         39        2.76        2.76
                            Afghanistan |         21        1.49        4.25
                                Albania |         22        1.56        5.81
                                Algeria |          3        0.21        6.02
                                 Angola |          1        0.07        6.09
                    Antigua and Barbuda |          1        0.07        6.17
                                Armenia |          1        0.07        6.24
                             Azerbaijan |          3        0.21        6.45
                           Bahamas, The |          3        0.21        6.66
                             Bangladesh |         41        2.91        9.57
                                Belarus |          1        0.07        9.64
                                 Belize |          1        0.07        9.71
                                  Benin |          2        0.14        9.85
                                Bolivia |          1        0.07        9.92
                 Bosnia and Herzegovina |         18        1.28       11.20
                                 Brazil |          1        0.07       11.27
                           Burkina Faso |         11        0.78       12.05
                               Cambodia |          2        0.14       12.19
                               Cameroon |          3        0.21       12.40
               Central African Republic |         11        0.78       13.18
                                   Chad |         10        0.71       13.89
                                  Chile |          2        0.14       14.03
                                  China |          4        0.28       14.32
                                Comoros |          6        0.43       14.74
                       Congo, Dem. Rep. |          3        0.21       14.95
                            Congo, Rep. |          1        0.07       15.02
                             Costa Rica |          3        0.21       15.24
                          Cote d'Ivoire |          4        0.28       15.52
                                Croatia |          1        0.07       15.59
                                   Cuba |          3        0.21       15.80
                               Djibouti |         11        0.78       16.58
                               Dominica |          1        0.07       16.65
                     Dominican Republic |          2        0.14       16.80
                                Ecuador |          2        0.14       16.94
                       Egypt, Arab Rep. |          2        0.14       17.08
                            El Salvador |          4        0.28       17.36
                      Equatorial Guinea |          2        0.14       17.51
                               Eswatini |          6        0.43       17.93
                               Ethiopia |         10        0.71       18.64
                                 France |          1        0.07       18.71
                            Gambia, The |          4        0.28       18.99
                                Georgia |          2        0.14       19.14
                                Germany |          1        0.07       19.21
                                  Ghana |          4        0.28       19.49
                                 Greece |          4        0.28       19.77
                              Guatemala |          1        0.07       19.84
                                 Guinea |          1        0.07       19.91
                          Guinea-Bissau |          2        0.14       20.06
                                 Guyana |          1        0.07       20.13
                                  Haiti |          5        0.35       20.48
                                Hungary |          2        0.14       20.62
                                  India |         15        1.06       21.69
                              Indonesia |         33        2.34       24.03
                     Iran, Islamic Rep. |          8        0.57       24.59
                                   Iraq |         48        3.40       27.99
                                  Italy |          4        0.28       28.28
                                  Japan |          4        0.28       28.56
                                 Jordan |         39        2.76       31.33
                             Kazakhstan |          4        0.28       31.61
                                  Kenya |         16        1.13       32.74
                               Kiribati |          2        0.14       32.88
                            Korea, Rep. |          2        0.14       33.03
                                 Kosovo |         18        1.28       34.30
                        Kyrgyz Republic |         18        1.28       35.58
                                Lao PDR |          3        0.21       35.79
                                Lebanon |         68        4.82       40.61
                                Liberia |          4        0.28       40.89
                                  Libya |          6        0.43       41.32
                             Madagascar |          2        0.14       41.46
                                 Malawi |          2        0.14       41.60
                               Malaysia |          8        0.57       42.17
                                   Mali |          9        0.64       42.81
                             Mauritania |         12        0.85       43.66
                                 Mexico |          5        0.35       44.01
                                Moldova |          4        0.28       44.29
                               Mongolia |          2        0.14       44.44
                             Montenegro |          1        0.07       44.51
                                Morocco |         10        0.71       45.22
                             Mozambique |          1        0.07       45.29
                                Myanmar |         21        1.49       46.78
                                  Nepal |         15        1.06       47.84
                            Netherlands |          1        0.07       47.91
                              Nicaragua |          1        0.07       47.98
                                  Niger |         13        0.92       48.90
                                Nigeria |          7        0.50       49.40
                        North Macedonia |          1        0.07       49.47
                                   Oman |          2        0.14       49.61
                               Pakistan |         43        3.05       52.66
                                 Panama |          1        0.07       52.73
                       Papua New Guinea |          1        0.07       52.80
                               Paraguay |          2        0.14       52.94
                                   Peru |          3        0.21       53.15
                            Philippines |          8        0.57       53.72
                                Romania |          1        0.07       53.79
                                 Rwanda |          4        0.28       54.08
                             San Marino |          1        0.07       54.15
                                Senegal |          4        0.28       54.43
                                 Serbia |          4        0.28       54.71
                           Sierra Leone |          6        0.43       55.14
                              Singapore |          1        0.07       55.21
                               Slovenia |          1        0.07       55.28
                                Somalia |         68        4.82       60.10
                           South Africa |          2        0.14       60.24
                            South Sudan |          6        0.43       60.67
                                  Spain |          1        0.07       60.74
                              Sri Lanka |          7        0.50       61.23
                    St. Kitts and Nevis |          1        0.07       61.30
         St. Vincent and the Grenadines |          1        0.07       61.37
                                  Sudan |         74        5.24       66.62
                   Syrian Arab Republic |        142       10.06       76.68
                             Tajikistan |          4        0.28       76.97
                               Tanzania |          5        0.35       77.32
                               Thailand |          6        0.43       77.75
                            Timor-Leste |          1        0.07       77.82
                                   Togo |          2        0.14       77.96
                                Tunisia |         13        0.92       78.88
                                 Turkey |         42        2.98       81.86
                           Turkmenistan |          2        0.14       82.00
                                 Uganda |          2        0.14       82.14
                                Ukraine |          3        0.21       82.35
                         United Kingdom |          3        0.21       82.57
                          United States |          4        0.28       82.85
                             Uzbekistan |          1        0.07       82.92
                                Vanuatu |          1        0.07       82.99
                          Venezuela, RB |          2        0.14       83.13
                                Vietnam |          2        0.14       83.27
                     West Bank and Gaza |        160       11.34       94.61
                            Yemen, Rep. |         74        5.24       99.86
                                 Zambia |          2        0.14      100.00
----------------------------------------+-----------------------------------
                                  Total |      1,411      100.00

. **1411 operations
. sort country

. keep country

. duplicates drop

Duplicates in terms of all variables

(1,282 observations deleted)

. drop if country=="."
(1 observation deleted)

. tab country

        Name of the recipient countries |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
                            Afghanistan |          1        0.78        0.78
                                Albania |          1        0.78        1.56
                                Algeria |          1        0.78        2.34
                                 Angola |          1        0.78        3.12
                    Antigua and Barbuda |          1        0.78        3.91
                                Armenia |          1        0.78        4.69
                             Azerbaijan |          1        0.78        5.47
                           Bahamas, The |          1        0.78        6.25
                             Bangladesh |          1        0.78        7.03
                                Belarus |          1        0.78        7.81
                                 Belize |          1        0.78        8.59
                                  Benin |          1        0.78        9.38
                                Bolivia |          1        0.78       10.16
                 Bosnia and Herzegovina |          1        0.78       10.94
                                 Brazil |          1        0.78       11.72
                           Burkina Faso |          1        0.78       12.50
                               Cambodia |          1        0.78       13.28
                               Cameroon |          1        0.78       14.06
               Central African Republic |          1        0.78       14.84
                                   Chad |          1        0.78       15.62
                                  Chile |          1        0.78       16.41
                                  China |          1        0.78       17.19
                                Comoros |          1        0.78       17.97
                       Congo, Dem. Rep. |          1        0.78       18.75
                            Congo, Rep. |          1        0.78       19.53
                             Costa Rica |          1        0.78       20.31
                          Cote d'Ivoire |          1        0.78       21.09
                                Croatia |          1        0.78       21.88
                                   Cuba |          1        0.78       22.66
                               Djibouti |          1        0.78       23.44
                               Dominica |          1        0.78       24.22
                     Dominican Republic |          1        0.78       25.00
                                Ecuador |          1        0.78       25.78
                       Egypt, Arab Rep. |          1        0.78       26.56
                            El Salvador |          1        0.78       27.34
                      Equatorial Guinea |          1        0.78       28.12
                               Eswatini |          1        0.78       28.91
                               Ethiopia |          1        0.78       29.69
                                 France |          1        0.78       30.47
                            Gambia, The |          1        0.78       31.25
                                Georgia |          1        0.78       32.03
                                Germany |          1        0.78       32.81
                                  Ghana |          1        0.78       33.59
                                 Greece |          1        0.78       34.38
                              Guatemala |          1        0.78       35.16
                                 Guinea |          1        0.78       35.94
                          Guinea-Bissau |          1        0.78       36.72
                                 Guyana |          1        0.78       37.50
                                  Haiti |          1        0.78       38.28
                                Hungary |          1        0.78       39.06
                                  India |          1        0.78       39.84
                              Indonesia |          1        0.78       40.62
                     Iran, Islamic Rep. |          1        0.78       41.41
                                   Iraq |          1        0.78       42.19
                                  Italy |          1        0.78       42.97
                                  Japan |          1        0.78       43.75
                                 Jordan |          1        0.78       44.53
                             Kazakhstan |          1        0.78       45.31
                                  Kenya |          1        0.78       46.09
                               Kiribati |          1        0.78       46.88
                            Korea, Rep. |          1        0.78       47.66
                                 Kosovo |          1        0.78       48.44
                        Kyrgyz Republic |          1        0.78       49.22
                                Lao PDR |          1        0.78       50.00
                                Lebanon |          1        0.78       50.78
                                Liberia |          1        0.78       51.56
                                  Libya |          1        0.78       52.34
                             Madagascar |          1        0.78       53.12
                                 Malawi |          1        0.78       53.91
                               Malaysia |          1        0.78       54.69
                                   Mali |          1        0.78       55.47
                             Mauritania |          1        0.78       56.25
                                 Mexico |          1        0.78       57.03
                                Moldova |          1        0.78       57.81
                               Mongolia |          1        0.78       58.59
                             Montenegro |          1        0.78       59.38
                                Morocco |          1        0.78       60.16
                             Mozambique |          1        0.78       60.94
                                Myanmar |          1        0.78       61.72
                                  Nepal |          1        0.78       62.50
                            Netherlands |          1        0.78       63.28
                              Nicaragua |          1        0.78       64.06
                                  Niger |          1        0.78       64.84
                                Nigeria |          1        0.78       65.62
                        North Macedonia |          1        0.78       66.41
                                   Oman |          1        0.78       67.19
                               Pakistan |          1        0.78       67.97
                                 Panama |          1        0.78       68.75
                       Papua New Guinea |          1        0.78       69.53
                               Paraguay |          1        0.78       70.31
                                   Peru |          1        0.78       71.09
                            Philippines |          1        0.78       71.88
                                Romania |          1        0.78       72.66
                                 Rwanda |          1        0.78       73.44
                             San Marino |          1        0.78       74.22
                                Senegal |          1        0.78       75.00
                                 Serbia |          1        0.78       75.78
                           Sierra Leone |          1        0.78       76.56
                              Singapore |          1        0.78       77.34
                               Slovenia |          1        0.78       78.12
                                Somalia |          1        0.78       78.91
                           South Africa |          1        0.78       79.69
                            South Sudan |          1        0.78       80.47
                                  Spain |          1        0.78       81.25
                              Sri Lanka |          1        0.78       82.03
                    St. Kitts and Nevis |          1        0.78       82.81
         St. Vincent and the Grenadines |          1        0.78       83.59
                                  Sudan |          1        0.78       84.38
                   Syrian Arab Republic |          1        0.78       85.16
                             Tajikistan |          1        0.78       85.94
                               Tanzania |          1        0.78       86.72
                               Thailand |          1        0.78       87.50
                            Timor-Leste |          1        0.78       88.28
                                   Togo |          1        0.78       89.06
                                Tunisia |          1        0.78       89.84
                                 Turkey |          1        0.78       90.62
                           Turkmenistan |          1        0.78       91.41
                                 Uganda |          1        0.78       92.19
                                Ukraine |          1        0.78       92.97
                         United Kingdom |          1        0.78       93.75
                          United States |          1        0.78       94.53
                             Uzbekistan |          1        0.78       95.31
                                Vanuatu |          1        0.78       96.09
                          Venezuela, RB |          1        0.78       96.88
                                Vietnam |          1        0.78       97.66
                     West Bank and Gaza |          1        0.78       98.44
                            Yemen, Rep. |          1        0.78       99.22
                                 Zambia |          1        0.78      100.00
----------------------------------------+-----------------------------------
                                  Total |        128      100.00

. ***128 countries
. 
. use "QATARAID_RAW.dta" ,clear
(QATARAID-RAW)

. tab country if bilatereal==1

        Name of the recipient countries |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
                                      . |          9        0.69        0.69
                            Afghanistan |         19        1.46        2.15
                                Albania |         22        1.69        3.83
                                Algeria |          3        0.23        4.06
                                 Angola |          1        0.08        4.14
                    Antigua and Barbuda |          1        0.08        4.21
                                Armenia |          1        0.08        4.29
                             Azerbaijan |          3        0.23        4.52
                           Bahamas, The |          2        0.15        4.67
                             Bangladesh |         35        2.68        7.36
                                Belarus |          1        0.08        7.43
                                  Benin |          2        0.15        7.59
                                Bolivia |          1        0.08        7.66
                 Bosnia and Herzegovina |         18        1.38        9.04
                                 Brazil |          1        0.08        9.12
                           Burkina Faso |         11        0.84        9.96
                               Cambodia |          2        0.15       10.11
                               Cameroon |          3        0.23       10.34
               Central African Republic |         11        0.84       11.19
                                   Chad |         10        0.77       11.95
                                  Chile |          2        0.15       12.11
                                  China |          4        0.31       12.41
                                Comoros |          5        0.38       12.80
                       Congo, Dem. Rep. |          3        0.23       13.03
                            Congo, Rep. |          1        0.08       13.10
                             Costa Rica |          3        0.23       13.33
                          Cote d'Ivoire |          4        0.31       13.64
                                Croatia |          1        0.08       13.72
                                   Cuba |          3        0.23       13.95
                               Djibouti |          9        0.69       14.64
                               Dominica |          1        0.08       14.71
                     Dominican Republic |          1        0.08       14.79
                                Ecuador |          2        0.15       14.94
                       Egypt, Arab Rep. |          2        0.15       15.10
                            El Salvador |          4        0.31       15.40
                      Equatorial Guinea |          2        0.15       15.56
                               Eswatini |          6        0.46       16.02
                               Ethiopia |          9        0.69       16.70
                                 France |          1        0.08       16.78
                            Gambia, The |          4        0.31       17.09
                                Georgia |          2        0.15       17.24
                                Germany |          1        0.08       17.32
                                  Ghana |          4        0.31       17.62
                                 Greece |          4        0.31       17.93
                              Guatemala |          1        0.08       18.01
                          Guinea-Bissau |          2        0.15       18.16
                                 Guyana |          1        0.08       18.24
                                  Haiti |          3        0.23       18.47
                                Hungary |          2        0.15       18.62
                                  India |         13        1.00       19.62
                              Indonesia |         32        2.45       22.07
                     Iran, Islamic Rep. |          8        0.61       22.68
                                   Iraq |         43        3.30       25.98
                                  Italy |          4        0.31       26.28
                                  Japan |          4        0.31       26.59
                                 Jordan |         33        2.53       29.12
                             Kazakhstan |          4        0.31       29.43
                                  Kenya |         15        1.15       30.57
                               Kiribati |          2        0.15       30.73
                            Korea, Rep. |          2        0.15       30.88
                                 Kosovo |         18        1.38       32.26
                        Kyrgyz Republic |         18        1.38       33.64
                                Lao PDR |          3        0.23       33.87
                                Lebanon |         65        4.98       38.85
                                Liberia |          3        0.23       39.08
                                  Libya |          6        0.46       39.54
                             Madagascar |          2        0.15       39.69
                                 Malawi |          2        0.15       39.85
                               Malaysia |          8        0.61       40.46
                                   Mali |          9        0.69       41.15
                             Mauritania |         12        0.92       42.07
                                 Mexico |          5        0.38       42.45
                                Moldova |          4        0.31       42.76
                               Mongolia |          2        0.15       42.91
                             Montenegro |          1        0.08       42.99
                                Morocco |         10        0.77       43.75
                             Mozambique |          1        0.08       43.83
                                Myanmar |         19        1.46       45.29
                                  Nepal |         15        1.15       46.44
                            Netherlands |          1        0.08       46.51
                              Nicaragua |          1        0.08       46.59
                                  Niger |         13        1.00       47.59
                                Nigeria |          7        0.54       48.12
                        North Macedonia |          1        0.08       48.20
                                   Oman |          2        0.15       48.35
                               Pakistan |         41        3.14       51.49
                                 Panama |          1        0.08       51.57
                       Papua New Guinea |          1        0.08       51.65
                               Paraguay |          2        0.15       51.80
                                   Peru |          3        0.23       52.03
                            Philippines |          8        0.61       52.64
                                Romania |          1        0.08       52.72
                                 Rwanda |          4        0.31       53.03
                             San Marino |          1        0.08       53.10
                                Senegal |          4        0.31       53.41
                                 Serbia |          4        0.31       53.72
                           Sierra Leone |          5        0.38       54.10
                              Singapore |          1        0.08       54.18
                               Slovenia |          1        0.08       54.25
                                Somalia |         65        4.98       59.23
                           South Africa |          2        0.15       59.39
                            South Sudan |          6        0.46       59.85
                                  Spain |          1        0.08       59.92
                              Sri Lanka |          7        0.54       60.46
                    St. Kitts and Nevis |          1        0.08       60.54
                                  Sudan |         72        5.52       66.05
                   Syrian Arab Republic |        128        9.81       75.86
                             Tajikistan |          4        0.31       76.17
                               Tanzania |          5        0.38       76.55
                               Thailand |          6        0.46       77.01
                            Timor-Leste |          1        0.08       77.09
                                   Togo |          2        0.15       77.24
                                Tunisia |         13        1.00       78.24
                                 Turkey |         42        3.22       81.46
                           Turkmenistan |          2        0.15       81.61
                                 Uganda |          2        0.15       81.76
                                Ukraine |          3        0.23       81.99
                         United Kingdom |          3        0.23       82.22
                          United States |          4        0.31       82.53
                             Uzbekistan |          1        0.08       82.61
                                Vanuatu |          1        0.08       82.68
                          Venezuela, RB |          2        0.15       82.84
                                Vietnam |          2        0.15       82.99
                     West Bank and Gaza |        150       11.49       94.48
                            Yemen, Rep. |         70        5.36       99.85
                                 Zambia |          2        0.15      100.00
----------------------------------------+-----------------------------------
                                  Total |      1,305      100.00

. dis 1305-9
1296

. *1296 aims a specific location
. *122-1 countries
. 
. tab country if bilatereal==0

        Name of the recipient countries |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
                                      . |         27       28.42       28.42
                            Afghanistan |          2        2.11       30.53
                             Bangladesh |          6        6.32       36.84
                                Comoros |          1        1.05       37.89
                               Djibouti |          2        2.11       40.00
                               Ethiopia |          1        1.05       41.05
                                 Guinea |          1        1.05       42.11
                                  Haiti |          1        1.05       43.16
                                  India |          2        2.11       45.26
                                   Iraq |          5        5.26       50.53
                                 Jordan |          6        6.32       56.84
                                  Kenya |          1        1.05       57.89
                                Lebanon |          3        3.16       61.05
                                Liberia |          1        1.05       62.11
                                Myanmar |          2        2.11       64.21
                               Pakistan |          2        2.11       66.32
                           Sierra Leone |          1        1.05       67.37
                                Somalia |          3        3.16       70.53
                                  Sudan |          1        1.05       71.58
                   Syrian Arab Republic |         14       14.74       86.32
                     West Bank and Gaza |         10       10.53       96.84
                            Yemen, Rep. |          3        3.16      100.00
----------------------------------------+-----------------------------------
                                  Total |         95      100.00

. dis 95-27
68

. *68
. * We observe 95 multilateral aid operations out of them 68 of them targets a specific location.
. 
. **Table 1
.  tab dumregion year, col nofreq

 region of recipient, |                    the year of aid interaction
              recoded |      2014       2015       2016       2017       2018       2019 |     Total
----------------------+------------------------------------------------------------------+----------
Middle East & North A |     55.56      48.18      45.80      31.38      37.71      40.59 |     42.90 
   Sub-Saharan Africa |     25.00      22.63      29.77      27.13      29.71      22.35 |     23.21 
  East Asia & Pacific |      8.33       9.49       9.16      11.17       8.57       6.47 |      7.39 
Europe & Central Asia |      6.48       8.03       6.11      14.89      10.29      14.71 |     12.45 
           South Asia |      4.63      11.68       8.40       8.51       9.71      14.12 |     10.32 
North America & Latin |      0.00       0.00       0.76       6.91       4.00       1.76 |      3.73 
----------------------+------------------------------------------------------------------+----------
                Total |    100.00     100.00     100.00     100.00     100.00     100.00 |    100.00 


                      |    the year of aid
 region of recipient, |      interaction
              recoded |      2020       2021 |     Total
----------------------+----------------------+----------
Middle East & North A |     39.06      51.34 |     42.90 
   Sub-Saharan Africa |     19.74      14.73 |     23.21 
  East Asia & Pacific |      5.58       3.12 |      7.39 
Europe & Central Asia |     18.03      13.84 |     12.45 
           South Asia |      8.15      14.73 |     10.32 
North America & Latin |      9.44       2.23 |      3.73 
----------------------+----------------------+----------
                Total |    100.00     100.00 |    100.00 

.  
. **Table 2. Distribution of Qatar's foreign aid by sector (2014–2021)
. tab sector_description , sort

    description of sectors for variable |
                 purposecode_dac_2digit |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
      Humanitarian & Emergency Response |        498       38.82       38.82
                                 Health |        203       15.82       54.64
                      Other Multisector |        101        7.87       62.51
 Other Social Infrastructure & Services |         91        7.09       69.60
                              Education |         80        6.24       75.84
            Refugees in Donor Countries |         74        5.77       81.61
              Water Supply & Sanitation |         66        5.14       86.75
            Development Food Assistance |         61        4.75       91.50
                            Multisector |         33        2.57       94.08
Government & Civil Society & Peace & .. |         25        1.95       96.02
         Industry, Mining, Construction |         18        1.40       97.43
         Agriculture, Forestry, Fishing |         15        1.17       98.60
                                 Energy |          5        0.39       98.99
Banking & Financial & Business Services |          3        0.23       99.22
 Reconstruction Relief & Rehabilitation |          3        0.23       99.45
                    Transport & Storage |          3        0.23       99.69
         General Environment Protection |          2        0.16       99.84
                 General Budget Support |          1        0.08       99.92
              Unallocated / Unspecified |          1        0.08      100.00
----------------------------------------+-----------------------------------
                                  Total |      1,283      100.00

. 
. use "QATARAID_PANEL.dta", clear
(QATARAID)

. tab year

the year of |
        aid |
interaction |      Freq.     Percent        Cum.
------------+-----------------------------------
       2014 |        194       12.50       12.50
       2015 |        194       12.50       25.00
       2016 |        194       12.50       37.50
       2017 |        194       12.50       50.00
       2018 |        194       12.50       62.50
       2019 |        194       12.50       75.00
       2020 |        194       12.50       87.50
       2021 |        194       12.50      100.00
------------+-----------------------------------
      Total |      1,552      100.00

. tab country

        Name of the recipient countries |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
                            Afghanistan |          8        0.52        0.52
                                Albania |          8        0.52        1.03
                                Algeria |          8        0.52        1.55
                                Andorra |          8        0.52        2.06
                                 Angola |          8        0.52        2.58
                    Antigua and Barbuda |          8        0.52        3.09
                              Argentina |          8        0.52        3.61
                                Armenia |          8        0.52        4.12
                              Australia |          8        0.52        4.64
                                Austria |          8        0.52        5.15
                             Azerbaijan |          8        0.52        5.67
                           Bahamas, The |          8        0.52        6.19
                                Bahrain |          8        0.52        6.70
                             Bangladesh |          8        0.52        7.22
                               Barbados |          8        0.52        7.73
                                Belarus |          8        0.52        8.25
                                Belgium |          8        0.52        8.76
                                 Belize |          8        0.52        9.28
                                  Benin |          8        0.52        9.79
                                 Bhutan |          8        0.52       10.31
                                Bolivia |          8        0.52       10.82
                 Bosnia and Herzegovina |          8        0.52       11.34
                               Botswana |          8        0.52       11.86
                                 Brazil |          8        0.52       12.37
                      Brunei Darussalam |          8        0.52       12.89
                               Bulgaria |          8        0.52       13.40
                           Burkina Faso |          8        0.52       13.92
                                Burundi |          8        0.52       14.43
                             Cabo Verde |          8        0.52       14.95
                               Cambodia |          8        0.52       15.46
                               Cameroon |          8        0.52       15.98
                                 Canada |          8        0.52       16.49
               Central African Republic |          8        0.52       17.01
                                   Chad |          8        0.52       17.53
                                  Chile |          8        0.52       18.04
                                  China |          8        0.52       18.56
                               Colombia |          8        0.52       19.07
                                Comoros |          8        0.52       19.59
                       Congo, Dem. Rep. |          8        0.52       20.10
                            Congo, Rep. |          8        0.52       20.62
                             Costa Rica |          8        0.52       21.13
                          Cote d'Ivoire |          8        0.52       21.65
                                Croatia |          8        0.52       22.16
                                   Cuba |          8        0.52       22.68
                                 Cyprus |          8        0.52       23.20
                                Czechia |          8        0.52       23.71
                                Denmark |          8        0.52       24.23
                               Djibouti |          8        0.52       24.74
                               Dominica |          8        0.52       25.26
                     Dominican Republic |          8        0.52       25.77
                                Ecuador |          8        0.52       26.29
                       Egypt, Arab Rep. |          8        0.52       26.80
                            El Salvador |          8        0.52       27.32
                      Equatorial Guinea |          8        0.52       27.84
                                Eritrea |          8        0.52       28.35
                                Estonia |          8        0.52       28.87
                               Eswatini |          8        0.52       29.38
                               Ethiopia |          8        0.52       29.90
                                   Fiji |          8        0.52       30.41
                                Finland |          8        0.52       30.93
                                 France |          8        0.52       31.44
                                  Gabon |          8        0.52       31.96
                            Gambia, The |          8        0.52       32.47
                                Georgia |          8        0.52       32.99
                                Germany |          8        0.52       33.51
                                  Ghana |          8        0.52       34.02
                              Gibraltar |          8        0.52       34.54
                                 Greece |          8        0.52       35.05
                              Greenland |          8        0.52       35.57
                                Grenada |          8        0.52       36.08
                                   Guam |          8        0.52       36.60
                              Guatemala |          8        0.52       37.11
                                 Guinea |          8        0.52       37.63
                          Guinea-Bissau |          8        0.52       38.14
                                 Guyana |          8        0.52       38.66
                                  Haiti |          8        0.52       39.18
                               Honduras |          8        0.52       39.69
                   Hong Kong SAR, China |          8        0.52       40.21
                                Hungary |          8        0.52       40.72
                                Iceland |          8        0.52       41.24
                                  India |          8        0.52       41.75
                              Indonesia |          8        0.52       42.27
                     Iran, Islamic Rep. |          8        0.52       42.78
                                   Iraq |          8        0.52       43.30
                                Ireland |          8        0.52       43.81
                                 Israel |          8        0.52       44.33
                                  Italy |          8        0.52       44.85
                                Jamaica |          8        0.52       45.36
                                  Japan |          8        0.52       45.88
                                 Jordan |          8        0.52       46.39
                             Kazakhstan |          8        0.52       46.91
                                  Kenya |          8        0.52       47.42
                            Korea, Rep. |          8        0.52       47.94
                                 Kosovo |          8        0.52       48.45
                                 Kuwait |          8        0.52       48.97
                        Kyrgyz Republic |          8        0.52       49.48
                                Lao PDR |          8        0.52       50.00
                                 Latvia |          8        0.52       50.52
                                Lebanon |          8        0.52       51.03
                                Lesotho |          8        0.52       51.55
                                Liberia |          8        0.52       52.06
                                  Libya |          8        0.52       52.58
                          Liechtenstein |          8        0.52       53.09
                              Lithuania |          8        0.52       53.61
                             Luxembourg |          8        0.52       54.12
                             Madagascar |          8        0.52       54.64
                                 Malawi |          8        0.52       55.15
                               Malaysia |          8        0.52       55.67
                               Maldives |          8        0.52       56.19
                                   Mali |          8        0.52       56.70
                                  Malta |          8        0.52       57.22
                             Mauritania |          8        0.52       57.73
                              Mauritius |          8        0.52       58.25
                                 Mexico |          8        0.52       58.76
                                Moldova |          8        0.52       59.28
                               Mongolia |          8        0.52       59.79
                             Montenegro |          8        0.52       60.31
                                Morocco |          8        0.52       60.82
                             Mozambique |          8        0.52       61.34
                                Myanmar |          8        0.52       61.86
                                Namibia |          8        0.52       62.37
                                  Nauru |          8        0.52       62.89
                                  Nepal |          8        0.52       63.40
                            Netherlands |          8        0.52       63.92
                          New Caledonia |          8        0.52       64.43
                            New Zealand |          8        0.52       64.95
                              Nicaragua |          8        0.52       65.46
                                  Niger |          8        0.52       65.98
                                Nigeria |          8        0.52       66.49
                        North Macedonia |          8        0.52       67.01
                                 Norway |          8        0.52       67.53
                                   Oman |          8        0.52       68.04
                               Pakistan |          8        0.52       68.56
                                 Panama |          8        0.52       69.07
                       Papua New Guinea |          8        0.52       69.59
                               Paraguay |          8        0.52       70.10
                                   Peru |          8        0.52       70.62
                            Philippines |          8        0.52       71.13
                                 Poland |          8        0.52       71.65
                               Portugal |          8        0.52       72.16
                            Puerto Rico |          8        0.52       72.68
                                Romania |          8        0.52       73.20
                     Russian Federation |          8        0.52       73.71
                                 Rwanda |          8        0.52       74.23
                                  Samoa |          8        0.52       74.74
                             San Marino |          8        0.52       75.26
                  Sao Tome and Principe |          8        0.52       75.77
                           Saudi Arabia |          8        0.52       76.29
                                Senegal |          8        0.52       76.80
                                 Serbia |          8        0.52       77.32
                             Seychelles |          8        0.52       77.84
                           Sierra Leone |          8        0.52       78.35
                              Singapore |          8        0.52       78.87
                        Slovak Republic |          8        0.52       79.38
                               Slovenia |          8        0.52       79.90
                        Solomon Islands |          8        0.52       80.41
                                Somalia |          8        0.52       80.93
                           South Africa |          8        0.52       81.44
                            South Sudan |          8        0.52       81.96
                                  Spain |          8        0.52       82.47
                              Sri Lanka |          8        0.52       82.99
                    St. Kitts and Nevis |          8        0.52       83.51
                              St. Lucia |          8        0.52       84.02
         St. Vincent and the Grenadines |          8        0.52       84.54
                                  Sudan |          8        0.52       85.05
                               Suriname |          8        0.52       85.57
                                 Sweden |          8        0.52       86.08
                            Switzerland |          8        0.52       86.60
                   Syrian Arab Republic |          8        0.52       87.11
                             Tajikistan |          8        0.52       87.63
                               Tanzania |          8        0.52       88.14
                               Thailand |          8        0.52       88.66
                            Timor-Leste |          8        0.52       89.18
                                   Togo |          8        0.52       89.69
                                  Tonga |          8        0.52       90.21
                    Trinidad and Tobago |          8        0.52       90.72
                                Tunisia |          8        0.52       91.24
                                 Turkey |          8        0.52       91.75
                           Turkmenistan |          8        0.52       92.27
                                 Tuvalu |          8        0.52       92.78
                                 Uganda |          8        0.52       93.30
                                Ukraine |          8        0.52       93.81
                   United Arab Emirates |          8        0.52       94.33
                         United Kingdom |          8        0.52       94.85
                          United States |          8        0.52       95.36
                                Uruguay |          8        0.52       95.88
                             Uzbekistan |          8        0.52       96.39
                                Vanuatu |          8        0.52       96.91
                          Venezuela, RB |          8        0.52       97.42
                                Vietnam |          8        0.52       97.94
                     West Bank and Gaza |          8        0.52       98.45
                            Yemen, Rep. |          8        0.52       98.97
                                 Zambia |          8        0.52       99.48
                               Zimbabwe |          8        0.52      100.00
----------------------------------------+-----------------------------------
                                  Total |      1,552      100.00

. sort country

. by country: egen cmeanaidinteractions=mean( aidinteractions)

. tab country if cmeanaidinteractions==0

        Name of the recipient countries |      Freq.     Percent        Cum.
----------------------------------------+-----------------------------------
                                Andorra |          8        1.47        1.47
                              Argentina |          8        1.47        2.94
                              Australia |          8        1.47        4.41
                                Austria |          8        1.47        5.88
                                Bahrain |          8        1.47        7.35
                               Barbados |          8        1.47        8.82
                                Belgium |          8        1.47       10.29
                                 Bhutan |          8        1.47       11.76
                               Botswana |          8        1.47       13.24
                      Brunei Darussalam |          8        1.47       14.71
                               Bulgaria |          8        1.47       16.18
                                Burundi |          8        1.47       17.65
                             Cabo Verde |          8        1.47       19.12
                                 Canada |          8        1.47       20.59
                               Colombia |          8        1.47       22.06
                          Cote d'Ivoire |          8        1.47       23.53
                                 Cyprus |          8        1.47       25.00
                                Czechia |          8        1.47       26.47
                                Denmark |          8        1.47       27.94
                                Eritrea |          8        1.47       29.41
                                Estonia |          8        1.47       30.88
                                   Fiji |          8        1.47       32.35
                                Finland |          8        1.47       33.82
                                  Gabon |          8        1.47       35.29
                              Gibraltar |          8        1.47       36.76
                              Greenland |          8        1.47       38.24
                                Grenada |          8        1.47       39.71
                                   Guam |          8        1.47       41.18
                               Honduras |          8        1.47       42.65
                   Hong Kong SAR, China |          8        1.47       44.12
                                Iceland |          8        1.47       45.59
                                Ireland |          8        1.47       47.06
                                 Israel |          8        1.47       48.53
                                Jamaica |          8        1.47       50.00
                                 Kuwait |          8        1.47       51.47
                                 Latvia |          8        1.47       52.94
                                Lesotho |          8        1.47       54.41
                          Liechtenstein |          8        1.47       55.88
                              Lithuania |          8        1.47       57.35
                             Luxembourg |          8        1.47       58.82
                               Maldives |          8        1.47       60.29
                                  Malta |          8        1.47       61.76
                              Mauritius |          8        1.47       63.24
                                Namibia |          8        1.47       64.71
                                  Nauru |          8        1.47       66.18
                          New Caledonia |          8        1.47       67.65
                            New Zealand |          8        1.47       69.12
                                 Norway |          8        1.47       70.59
                                 Poland |          8        1.47       72.06
                               Portugal |          8        1.47       73.53
                            Puerto Rico |          8        1.47       75.00
                     Russian Federation |          8        1.47       76.47
                                  Samoa |          8        1.47       77.94
                  Sao Tome and Principe |          8        1.47       79.41
                           Saudi Arabia |          8        1.47       80.88
                             Seychelles |          8        1.47       82.35
                        Slovak Republic |          8        1.47       83.82
                        Solomon Islands |          8        1.47       85.29
                              St. Lucia |          8        1.47       86.76
                               Suriname |          8        1.47       88.24
                                 Sweden |          8        1.47       89.71
                            Switzerland |          8        1.47       91.18
                                  Tonga |          8        1.47       92.65
                    Trinidad and Tobago |          8        1.47       94.12
                                 Tuvalu |          8        1.47       95.59
                   United Arab Emirates |          8        1.47       97.06
                                Uruguay |          8        1.47       98.53
                               Zimbabwe |          8        1.47      100.00
----------------------------------------+-----------------------------------
                                  Total |        544      100.00

. dis 544/8
68

. *68 countries
. 
. **Table 3. Descriptive Statistics (2014–2021) 
. use "QATARAID_PANEL_ESTIMATIONS.dta", clear
(QATARAID)

. sum aidinteractions aidstatus political_interests qatarblockade polity2 v2x_polyarchy mediation_new
>  muslimmajority arableague ln_qatarimports_un_v2 ln_qatarexports_un_v2 ln_qatartrade  ln_gdp_per_ca
> pita_WB gdppc_growth lninfant ln_pop qatardistance

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
aidinterac~s |      1,552    .8801546    2.737342          0         38
   aidstatus |      1,552    .2789948    .4486495          0          1
political_~s |      1,552    3.160438     5.22696          0         63
qatarblock~e |      1,552    .0386598     .192845          0          1
     polity2 |        802    4.336658    5.953534        -10         10
-------------+---------------------------------------------------------
v2x_polyar~y |      1,368    .5279496    .2534621       .015       .923
mediation_~w |      1,552    .0103093    .1010424          0          1
muslimmajo~y |      1,552    .2474227    .4316535          0          1
  arableague |      1,552    .1082474    .3107928          0          1
ln_qatarim~2 |      1,552     6.15453    5.043467          0   15.62672
-------------+---------------------------------------------------------
ln_qatarex~2 |      1,552    6.915384     4.75507          0   17.32073
ln_qatartr~e |      1,490    8.215969    4.547904          0   17.37778
ln_gdp_per~B |      1,504    8.712346     1.42019   5.411034   12.09439
gdppc_growth |      1,505    1.183462    5.279632  -34.77656   43.75871
    lninfant |      1,496    2.605087    1.058182   .4054651   4.564348
-------------+---------------------------------------------------------
      ln_pop |      1,552    15.63074    2.163403    9.28989   21.06853
qatardista~e |      1,512    8.518508    .7627379   4.934521   9.632418

.  
. log close
-----------------------------------------------------------------------------------------------------
